retrieve a record by its id